USE [RD_SalesMart]
GO

/****** Object:  Index [PK_Sales_Star_Facts]    Script Date: 05/21/2010 13:44:02 ******/
ALTER TABLE [dbo].[Sales_Star_Facts] ADD  CONSTRAINT [PK_Sales_Star_Facts] PRIMARY KEY CLUSTERED 
(
	[OrderNumberDocumentCompany] ASC,
	[OrderNumber] ASC,
	[OrderTypeCode] ASC,
	[LineNumber] ASC,
	[OrderSuffix] ASC,
	[TransactionType] ASC,
	[ItemNumber] ASC,
	[BusinessUnitCode] ASC,
	[RequestedDateID] ASC,
	[AddressNumber] ASC,
	[ForecastType] ASC,
	[YearCalendarYear] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO


USE [RD_SalesMart]
GO

/****** Object:  Index [IX_AddressNumber_BusinessUnit]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [IX_AddressNumber_BusinessUnit] ON [dbo].[Sales_Star_Facts] 
(
	[AddressNumber] ASC,
	[BusinessUnitCode] ASC,
	[FactsExtID] ASC,
	[ForecastType] ASC,
	[LineNumber] ASC,
	[ItemNumber] ASC,
	[OrderNumber] ASC,
	[OrderNumberDocumentCompany] ASC,
	[OrderSuffix] ASC,
	[OrderTypeCode] ASC,
	[TransactionType] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_ActualDeliveryDate]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_ActualDeliveryDate] ON [dbo].[Sales_Star_Facts] 
(
	[ActualDeliveryDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_AddressNumber]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_AddressNumber] ON [dbo].[Sales_Star_Facts] 
(
	[AddressNumber] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_BusinessUnitID]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_BusinessUnitID] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_CancelDateID]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_CancelDateID] ON [dbo].[Sales_Star_Facts] 
(
	[CancelDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_CompanyID]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_CompanyID] ON [dbo].[Sales_Star_Facts] 
(
	[CompanyNumberID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_CostID]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_CostID] ON [dbo].[Sales_Star_Facts] 
(
	[CostID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_FactsExtID]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_FactsExtID] ON [dbo].[Sales_Star_Facts] 
(
	[FactsExtID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_FactsHdrID]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_FactsHdrID] ON [dbo].[Sales_Star_Facts] 
(
	[FactsHdrID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_GLDate]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_GLDate] ON [dbo].[Sales_Star_Facts] 
(
	[GLDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_InvoiceDate]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_InvoiceDate] ON [dbo].[Sales_Star_Facts] 
(
	[InvoiceDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_ItemNum_UOMAsInput]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_ItemNum_UOMAsInput] ON [dbo].[Sales_Star_Facts] 
(
	[ItemNumber] ASC,
	[UnitOfMeasureAsInput] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_ItemNum_UOMPrimary]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_ItemNum_UOMPrimary] ON [dbo].[Sales_Star_Facts] 
(
	[ItemNumber] ASC,
	[UnitOfMeasurePrimary] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_ItemNumberID]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_ItemNumberID] ON [dbo].[Sales_Star_Facts] 
(
	[ItemNumberID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_OrderTypeCode]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_OrderTypeCode] ON [dbo].[Sales_Star_Facts] 
(
	[OrderTypeCode] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_OriginalPromisedDate]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_OriginalPromisedDate] ON [dbo].[Sales_Star_Facts] 
(
	[OriginalPromisedDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_ParentNumber]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_ParentNumber] ON [dbo].[Sales_Star_Facts] 
(
	[ParentNumber] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_PriceEffectiveDate]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_PriceEffectiveDate] ON [dbo].[Sales_Star_Facts] 
(
	[PriceEffectiveDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_PriceID]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_PriceID] ON [dbo].[Sales_Star_Facts] 
(
	[PriceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_PromisedDelDate]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_PromisedDelDate] ON [dbo].[Sales_Star_Facts] 
(
	[PromisedDeliveryDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_RequestedDate]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_RequestedDate] ON [dbo].[Sales_Star_Facts] 
(
	[RequestedDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_SalesRepID]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_SalesRepID] ON [dbo].[Sales_Star_Facts] 
(
	[SalesRepID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_ShipDate]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_ShipDate] ON [dbo].[Sales_Star_Facts] 
(
	[ShipDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_ShipToNumber]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_ShipToNumber] ON [dbo].[Sales_Star_Facts] 
(
	[ShiptoNumber] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_TransactionDate]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_TransactionDate] ON [dbo].[Sales_Star_Facts] 
(
	[TransactionDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_TranTypeID]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_TranTypeID] ON [dbo].[Sales_Star_Facts] 
(
	[TransactionTypeID] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_TypeID]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_TypeID] ON [dbo].[Sales_Star_Facts] 
(
	[TypeID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_UOMPrimary]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_UOMPrimary] ON [dbo].[Sales_Star_Facts] 
(
	[UnitOfMeasurePrimary] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_ORDERSuffix]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [IX_ORDERSuffix] ON [dbo].[Sales_Star_Facts] 
(
	[OrderSuffix] ASC,
	[OrderTypeCode] ASC
)
INCLUDE ( [SourceID],
[OrderNumber]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_10]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_10] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC,
	[ItemNumber02] ASC,
	[HeaderBusinessUnit] ASC,
	[OrderTypeCode] ASC,
	[LineType] ASC
)
INCLUDE ( [ItemNumberID],
[ItemNumber],
[GLDateID],
[QuantityShipped],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_114]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_114] ON [dbo].[Sales_Star_Facts] 
(
	[OrderNumber] ASC
)
INCLUDE ( [FactsExtID],
[ItemNumberID],
[LineNumber],
[BusinessUnitCode],
[ShiptoNumber],
[ItemNumber],
[ItemNumber02],
[InvoiceDateID],
[QuantityShipped],
[ExtendedPrice],
[UnitOfMeasureAsInput],
[ParentNumber]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_116]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_116] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC
)
INCLUDE ( [ItemNumberID],
[ItemNumber],
[GLDateID],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_137]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_137] ON [dbo].[Sales_Star_Facts] 
(
	[OrderNumber] ASC,
	[OrderTypeCode] ASC
)
INCLUDE ( [FactsExtID],
[FactsHdrID],
[SourceID],
[OrderNumberDocumentCompany],
[LineNumber],
[OrderSuffix],
[TransactionType],
[BusinessUnitCode],
[AddressNumber],
[ItemNumber],
[RequestedDateID],
[ForecastType],
[YearCalendarYear]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_1430]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_1430] ON [dbo].[Sales_Star_Facts] 
(
	[CustomerNumberID] ASC
)
INCLUDE ( [ItemNumberID],
[ItemNumber],
[InvoiceDateID],
[QuantityShipped],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_18]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_18] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC,
	[OrderTypeCode] ASC,
	[LineType] ASC,
	[HeaderBusinessUnit] ASC
)
INCLUDE ( [ItemNumberID],
[ItemNumber],
[ItemNumber02],
[QuantityShipped],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_20]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_20] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC,
	[OrderTypeCode] ASC,
	[LineType] ASC,
	[HeaderBusinessUnit] ASC
)
INCLUDE ( [ItemNumberID],
[ItemNumber],
[ItemNumber02],
[GLDateID],
[QuantityShipped],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_24]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_24] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC,
	[OrderTypeCode] ASC,
	[LineType] ASC,
	[HeaderBusinessUnit] ASC
)
INCLUDE ( [ItemNumberID],
[ItemNumber],
[ItemNumber02],
[GLDateID],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_251]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_251] ON [dbo].[Sales_Star_Facts] 
(
	[UnitOfMeasureAsInput] ASC
)
INCLUDE ( [SourceID],
[ItemNumber]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_257]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_257] ON [dbo].[Sales_Star_Facts] 
(
	[InvoiceDateID] ASC
)
INCLUDE ( [CustomerNumberID],
[ItemNumber],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_262]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_262] ON [dbo].[Sales_Star_Facts] 
(
	[GLDateID] ASC
)
INCLUDE ( [CustomerNumberID],
[ItemNumberID],
[ShiptoNumber],
[ItemNumber],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_301]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_301] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC,
	[ItemNumber02] ASC,
	[HeaderBusinessUnit] ASC,
	[OrderTypeCode] ASC,
	[LineType] ASC
)
INCLUDE ( [ItemNumberID],
[OrderNumber],
[ItemNumber],
[GLDateID],
[QuantityShipped],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_306]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_306] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC,
	[HeaderBusinessUnit] ASC,
	[OrderTypeCode] ASC,
	[LineType] ASC
)
INCLUDE ( [ItemNumberID],
[ItemNumber],
[ItemNumber02],
[GLDateID],
[QuantityShipped],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_308]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_308] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC,
	[HeaderBusinessUnit] ASC,
	[OrderTypeCode] ASC,
	[LineType] ASC
)
INCLUDE ( [ItemNumberID],
[OrderNumber],
[ItemNumber],
[ItemNumber02],
[GLDateID],
[QuantityShipped],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_318]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_318] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC,
	[OrderTypeCode] ASC,
	[LineType] ASC,
	[HeaderBusinessUnit] ASC
)
INCLUDE ( [ItemNumberID],
[ItemNumber],
[GLDateID],
[QuantityShipped],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_328]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_328] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC,
	[TransactionType] ASC
)
INCLUDE ( [CustomerNumberID],
[ItemNumberID],
[OrderNumber],
[LineNumber],
[ItemNumber],
[ItemNumber02],
[GLDateID],
[QuantityShipped],
[ExtendedPrice],
[UnitOfMeasureAsInput],
[HeaderBusinessUnit]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_415]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_415] ON [dbo].[Sales_Star_Facts] 
(
	[OrderTypeCode] ASC,
	[HeaderBusinessUnit] ASC
)
INCLUDE ( [ItemNumber],
[GLDateID],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_430]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_430] ON [dbo].[Sales_Star_Facts] 
(
	[HeaderBusinessUnit] ASC,
	[OrderTypeCode] ASC
)
INCLUDE ( [ItemNumber],
[GLDateID],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_433]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_433] ON [dbo].[Sales_Star_Facts] 
(
	[GLDateID] ASC,
	[OrderTypeCode] ASC,
	[HeaderBusinessUnit] ASC
)
INCLUDE ( [ItemNumber],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_452]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_452] ON [dbo].[Sales_Star_Facts] 
(
	[HeaderBusinessUnit] ASC,
	[OrderTypeCode] ASC
)
INCLUDE ( [LineType],
[ItemNumber],
[GLDateID],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_454]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_454] ON [dbo].[Sales_Star_Facts] 
(
	[OrderTypeCode] ASC,
	[LineType] ASC,
	[HeaderBusinessUnit] ASC
)
INCLUDE ( [ItemNumber],
[GLDateID],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_463]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_463] ON [dbo].[Sales_Star_Facts] 
(
	[HeaderBusinessUnit] ASC,
	[OrderTypeCode] ASC
)
INCLUDE ( [ItemNumberID],
[ItemNumber],
[GLDateID],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_465]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_465] ON [dbo].[Sales_Star_Facts] 
(
	[OrderTypeCode] ASC,
	[HeaderBusinessUnit] ASC
)
INCLUDE ( [ItemNumberID],
[ItemNumber],
[GLDateID],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_472]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_472] ON [dbo].[Sales_Star_Facts] 
(
	[HeaderBusinessUnit] ASC,
	[OrderTypeCode] ASC
)
INCLUDE ( [FactsExtID],
[ItemNumber],
[GLDateID],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_474]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_474] ON [dbo].[Sales_Star_Facts] 
(
	[OrderTypeCode] ASC,
	[HeaderBusinessUnit] ASC
)
INCLUDE ( [FactsExtID],
[ItemNumber],
[GLDateID],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_476]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_476] ON [dbo].[Sales_Star_Facts] 
(
	[HeaderBusinessUnit] ASC,
	[OrderTypeCode] ASC
)
INCLUDE ( [FactsExtID],
[ItemNumberID],
[ItemNumber],
[GLDateID],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_478]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_478] ON [dbo].[Sales_Star_Facts] 
(
	[OrderTypeCode] ASC,
	[HeaderBusinessUnit] ASC
)
INCLUDE ( [FactsExtID],
[ItemNumberID],
[ItemNumber],
[GLDateID],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_610]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_610] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC
)
INCLUDE ( [OrderNumber],
[ItemNumber],
[InvoiceDateID],
[ExtendedPrice],
[ExtendedCost],
[UnitOfMeasureAsInput],
[HeaderBusinessUnit]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_625]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_625] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC,
	[HeaderBusinessUnit] ASC
)
INCLUDE ( [OrderNumber],
[ItemNumber],
[InvoiceDateID],
[ExtendedPrice],
[ExtendedCost],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_9]    Script Date: 05/21/2010 13:43:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_9] ON [dbo].[Sales_Star_Facts] 
(
	[GLDateID] ASC,
	[OrderTypeCode] ASC
)
INCLUDE ( [ItemNumberID],
[ItemNumber],
[QuantityShipped],
[ExtendedPrice],
[ExtendedCost],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO


CREATE INDEX missing_index_77 ON [RD_SalesMart].[dbo].[Sales_Star_Facts] ([InvoiceDateID]) INCLUDE ([FactsExtID], [CustomerNumberID], [ItemNumber], [GLDateID], [ExtendedPrice], [ExtendedCost], [UnitOfMeasureAsInput])	
CREATE INDEX missing_index_645 ON [RD_SalesMart].[dbo].[Sales_Star_Facts] ([CustomerNumberID]) INCLUDE ([ItemNumberID], [OrderNumber], [LineNumber], [ShiptoNumber], [ItemNumber], [UnitOfMeasureAsInput])	
CREATE INDEX missing_index_297 ON [RD_SalesMart].[dbo].[Sales_Star_Facts] ([GLDateID]) INCLUDE ([FactsExtID], [ExtendedPrice], [ExtendedCost])	
CREATE INDEX missing_index_147 ON [RD_SalesMart].[dbo].[Sales_Star_Facts] ([InvoiceDateID]) INCLUDE ([FactsExtID], [CustomerNumberID], [ItemNumberID], [ItemNumber], [GLDateID], [QuantityShipped], [ExtendedPrice], [ExtendedCost], [UnitOfMeasureAsInput])	

CREATE INDEX missing_index_461 ON [RD_SalesMart].[dbo].[Sales_Star_Facts] ([GLDateID]) INCLUDE ([FactsExtID])	

CREATE INDEX missing_index_459 ON [RD_SalesMart].[dbo].[Sales_Star_Facts] ([GLDateID]) INCLUDE ([FactsExtID], [ExtendedPrice], [ExtendedCost])	

CREATE INDEX missing_index_656 ON [RD_SalesMart].[dbo].[Sales_Star_Facts] ([HeaderBusinessUnit]) INCLUDE ([FactsExtID], [ItemNumberID], [OrderNumber], [LineNumber], [ItemNumber], [GLDateID], [QuantityShipped], [ExtendedPrice], [ExtendedCost], [UnitOfMeasureAsInput])	

CREATE INDEX missing_index_560 ON [RD_SalesMart].[dbo].[Sales_Star_Facts] ([TransactionType], [OrderTypeCode]) INCLUDE ([ItemNumberID], [OrderNumber], [LineNumber], [ShiptoNumber], [ItemNumber], [GLDateID], [QuantityShipped], [ExtendedPrice], [UnitOfMeasureAsInput])	
CREATE INDEX missing_index_619 ON [RD_SalesMart].[dbo].[Sales_Star_Facts] ([ShiptoNumber]) INCLUDE ([FactsExtID], [CustomerNumberID], [OrderNumber], [OrderTypeCode], [LineNumber], [ItemNumber], [GLDateID], [QuantityShipped], [ExtendedPrice], [UnitOfMeasureAsInput])	

CREATE INDEX missing_index_554 ON [RD_SalesMart].[dbo].[Sales_Star_Facts] ([ShiptoNumber]) INCLUDE ([ItemNumberID], [OrderNumber], [LineNumber], [ItemNumber], [GLDateID], [QuantityShipped], [ExtendedPrice], [UnitOfMeasureAsInput])	

CREATE INDEX missing_index_280 ON [RD_SalesMart].[dbo].[Sales_Star_Facts] ([OrderTypeCode]) INCLUDE ([ItemNumberID], [OrderNumber], [LineNumber], [ShiptoNumber], [ItemNumber], [GLDateID], [QuantityShipped], [ExtendedPrice], [UnitOfMeasureAsInput])	
CREATE INDEX missing_index_399 ON [RD_SalesMart].[dbo].[Sales_Star_Facts] ([ShiptoNumber]) INCLUDE ([FactsExtID], [CustomerNumberID], [OrderNumber], [LineNumber], [ItemNumber], [GLDateID], [QuantityShipped], [ExtendedPrice], [UnitOfMeasureAsInput])	
CREATE INDEX missing_index_558 ON [RD_SalesMart].[dbo].[Sales_Star_Facts] ([ShiptoNumber]) INCLUDE ([ItemNumberID], [OrderNumber], [OrderTypeCode], [LineNumber], [ItemNumber], [GLDateID], [QuantityShipped], [ExtendedPrice], [UnitOfMeasureAsInput])	

CREATE INDEX missing_index_621 ON [RD_SalesMart].[dbo].[Sales_Star_Facts] ([TransactionTypeID]) INCLUDE ([CustomerNumberID], [ItemNumberID], [OrderNumber], [LineNumber], [ShiptoNumber], [ItemNumber], [InvoiceDateID], [QuantityShipped], [ExtendedPrice], [UnitOfMeasureAsInput])	

CREATE INDEX missing_index_435 ON [RD_SalesMart].[dbo].[Sales_Star_Facts] ([ShiptoNumber]) INCLUDE ([FactsExtID], [CustomerNumberID], [OrderNumber], [LineNumber], [ItemNumber], [GLDateID], [QuantityShipped], [ExtendedPrice], [ExtendedCost], [UnitOfMeasureAsInput])	
CREATE INDEX missing_index_654 ON [RD_SalesMart].[dbo].[Sales_Star_Facts] ([TransactionTypeID]) INCLUDE ([CustomerNumberID], [OrderNumber], [LineNumber], [ShiptoNumber], [ItemNumber], [InvoiceDateID], [QuantityShipped], [ExtendedPrice], [UnitOfMeasureAsInput])	

CREATE INDEX missing_index_503 ON [RD_SalesMart].[dbo].[Sales_Star_Facts] ([ItemNumber02]) INCLUDE ([FactsHdrID])	
CREATE INDEX missing_index_530 ON [RD_SalesMart].[dbo].[Sales_Star_Facts] ([ShiptoNumber], [OrderTypeCode]) INCLUDE ([ItemNumberID], [OrderNumber], [LineNumber], [ItemNumber], [GLDateID], [QuantityShipped], [ExtendedPrice], [UnitOfMeasureAsInput])	

CREATE INDEX missing_index_465 ON [RD_SalesMart].[dbo].[Sales_Star_Facts] ([BusinessUnitID]) INCLUDE ([FactsHdrID], [CustomerNumberID], [ItemNumberID], [SourceID], [OrderNumberDocumentCompany], [OrderNumber], [OrderTypeCode], [LineNumber], [ShiptoNumber], [ItemNumber], [InvoiceDateID], [UnitOfMeasureAsInput])	
CREATE INDEX missing_index_616 ON [RD_SalesMart].[dbo].[Sales_Star_Facts] ([ItemNumberID]) INCLUDE ([FactsHdrID], [BusinessUnitID], [CustomerNumberID], [SourceID], [OrderNumberDocumentCompany], [OrderNumber], [OrderTypeCode], [LineNumber], [ShiptoNumber], [ItemNumber], [InvoiceDateID], [UnitOfMeasureAsInput])	

CREATE INDEX missing_index_401 ON [RD_SalesMart].[dbo].[Sales_Star_Facts] ([ShiptoNumber]) INCLUDE ([FactsHdrID], [BusinessUnitID], [CustomerNumberID], [ItemNumberID], [SourceID], [OrderNumberDocumentCompany], [OrderNumber], [OrderTypeCode], [LineNumber], [ItemNumber], [InvoiceDateID], [UnitOfMeasureAsInput])	

CREATE INDEX missing_index_532 ON [RD_SalesMart].[dbo].[Sales_Star_Facts] ([CustomerNumberID]) INCLUDE ([FactsHdrID], [BusinessUnitID], [ItemNumberID], [SourceID], [OrderNumberDocumentCompany], [OrderNumber], [OrderTypeCode], [LineNumber], [ShiptoNumber], [ItemNumber], [InvoiceDateID], [UnitOfMeasureAsInput])	

CREATE INDEX missing_index_299 ON [RD_SalesMart].[dbo].[Sales_Star_FactsExt] ([OrderTypeCode]) INCLUDE ([FactsExtID])	

